package footprint.kwlee.app.db;

public class Fp_Database_sql {
	static final String DB ="footprint.db";
	public static final String BIGFOOTPRINT = "bigfootprint";
	public static final String DETAILFOOTPRINT = "detailfootprint";
	
	static final int DB_VERSION=1;
	
//	static final String CREATE_BIGFOOTPRINT =			
//        "CREATE TABLE bigfootprint (" +
//		  "b_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," + 
//		  "big_subject TEXT,"+ 
//		  "big_startdate TEXT," + 
//		  "big_enddate TEXT, " +
//		  "temp1 TEXT," + 
//		  "temp2 TEXT);";
//	
//	static final String CREATE_DETAILFOOTPRINT = 
//		"CREATE TABLE detailfootprint (" +
//		  "d_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, " +
//		  "detail_date TEXT, " +
//		  "detail_time TEXT, " +
//		  "detail_pic1 TEXT, " +
//		  "detail_pic2 TEXT, " +
//		  "detail_pic3 TEXT, " +
//		  "detail_memo TEXT, " +
//		  "detail_addr TEXT, " +
//		  "member_pwd TEXT, " +
//		  "temp1 TEXT, " +
//		  "temp2 TEXT, " +
//		  "b_id INTEGER NOT NULL CONSTRAINT b_id REFERENCES bigfootprint(b_id));";
	
	static final String CREATE_BIGFOOTPRINT =			
	  "CREATE TABLE bigfootprint (" +
		  "_id INTEGER PRIMARY KEY AUTOINCREMENT," + 
		  "big_subject TEXT,"+ 
		  "big_startdate TEXT ," + 
		  "big_enddate TEXT, " +
		  "big_pic1_path TEXT," + 
		  "detailpic_cnt INTEGER," + 
		  "detailepi_cnt INTEGER);";

	static final String CREATE_DETAILFOOTPRINT = 
		"CREATE TABLE detailfootprint (" +
		  "_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
		  "bigfootprint_id INTEGER, " +
		  "detail_date TEXT, " +
		  "detail_time TEXT, " +
		  "detail_pic1_path TEXT, " +
		  "detail_pic2_path TEXT, " +
		  "detail_pic3_path TEXT, " +
		  "detail_memo TEXT, " +
		  "detail_addr TEXT, " +
		  "member_pwd TEXT, " +
		  "detail_kind TEXT, " +
		  "latitude TEXT, " +
		  "longitude TEXT, " +
		  "temp2 TEXT);";	
	
	static final String DROP_BIGFOOTPRINT = "drop table bigfootprint;";
	
	static final String DROP_DETAILFOOTPRINT = "drop table detailfootprint;";
	
}
